<%@ page import="wtc.stu.dao.StuDaoIntegratedQuery" %>
<%@ page import="wtc.stu.entity.StuEntity" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: 马可
  Date: 2022/10/30
  Time: 18:40
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <link rel="stylesheet" href="css/tableFive.css" type="text/css">
    <link rel="stylesheet" href="css/options.css" type="text/css">
    <title>综合查询成绩信息</title>
</head>
<body>
<%--信息一览功能--%>
<div class="table">
    <table>
        <caption>学生成绩总览</caption>
        <thead>
        <tr>
            <th>学生编号</th>
            <th>学生姓名</th>
            <th>班级名称</th>
            <th>年级名称</th>
            <th>系别名称</th>
            <th>专业名称</th>
            <th>成绩</th>
        </tr>
        </thead>
        <%--从数据库获取上述字段的数据--%>
        <%
            // 通过对应类的getAll方法从数据库获取数据并存储到列表当中，遍历列表以获取各字段的数据
            StuDaoIntegratedQuery daoIntegratedQuery = new StuDaoIntegratedQuery();
            List<StuEntity> ar = daoIntegratedQuery.getAllScore();
            for (StuEntity stuEntity : ar) {
        %>
        <tbody>
        <tr>
            <td><%=stuEntity.getSid() %>
            </td>
            <td><%=stuEntity.getSname() %>
            </td>
            <td><%=stuEntity.getCname() %>
            </td>
            <td><%=stuEntity.getGname()%>
            </td>
            <td><%=stuEntity.getXname()%>
            </td>
            <td><%=stuEntity.getZname()%>
            </td>
            <td><%=stuEntity.getScore()%>
            </td>
            <td class="xg" style="display: none"></td>
            <%
                }
            %>
            <td style="display: none"></td>
        </tr>
        <tr>
            <td colspan="9" align="center" class="options"></td>
        </tr>
        </tbody>
    </table>
</div>
</body>
</html>
